Labels:chat room | crt screen | hakham | monitor | sky OCR: DATABASES 651 JOINING TABLES How data retrieved from more than one table at a time? Recall that the process of normalization creates tables that can be related by fields that exist in both tables. In SQL terminology, creating a relationship between tables IS referred to as joining tables Suppose you want some information on Elvis Presley's G.I Blues album. would be nice to see not only the album name and cover, but also a list the songs included on the album. The songs, however, are not stored in the FIGURE 11-50 same table as the res of the album data. The Albums table holds the album Records in the Albums table and name the artist's name the release date and other data about the album Tracks table both include Cat# The Tracks table holds the name of each song track, the track length, and ...
